﻿CREATE TABLE tHolidayType
(
	holidayTypeId INT NOT NULL CONSTRAINT [pk_tHolidayType_holidayTypeId] PRIMARY KEY ,
	typeName VARCHAR(250) NOT NULL,
	[description] VARCHAR(500) NULL,
	dateEntered_utc DATETIME2 NOT NULL CONSTRAINT [df_tHolidayType_dateEntered_utc] DEFAULT GETUTCDATE()
)